select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Two-toned Quinceanera Party Dress with Appliques and Pick Ups
Cheap Ball Gown Ruffled Beaded Two-toned Quince dresses
Sweetheart Beaded Multi-color Quinceanera Gown with Pick Ups
Special Multi-color Printing Pick Ups Ball Gown Quinces Dresses
Special Ruffled Beaded Multi-color Tiered Dresses for Sweet 15
Custom Made Ball Gown Medium Orchid Sweet Sixteen Dresses
Lilac Ruffled Beaded Ball Gown Dresses for Quince for Autumn
Green Sweetheart Beaded Sweet 16 Dress with Rolling Flowers
Ball Gown Multi-color Dresses for Sweet 15 with Ruffled Layers
Simple Style Orange Red Beaded Ball Gown Quinceanera Dresses
Ruched Beaded Pink Ball Gown Sweet 16 Dresses with Flower
Corset Back Pick Ups Purple Ball Gown Quinceanera Dresses
Green Organza Quinceanera Dress with Beading and Ruffles
Pink One Shoulder Ball Gown Quinceanera Dresses with Appliques
Turquoise Ball Gown Floor-length Taffeta Quinceanera Dresses
Baby Blue Ball Gown Sweet 16 Dresses with Appliques and Pick-ups
Spring Green Ball Gown Floor-length Quinceanera Dresses
Charming Spring Green Ball Gown Quinceneara Dresses with Appliques
Yellow Ball Gown Quinceanera Dresses with Hand-made Flowers
Multi-color Ball Gown Ruffled Organza Quinceneara Dresses
Discount Lilac Beaded Ball Gown Tulle Sweet Sixteen Dresses
Red One Shoulder Beaded Ball Gown Tulle Sweet 15 Dresses
Multi-color Strapless Ball Gown Ruffled Quinceneara Dresses
Royal Blue Ball Gown Ruffled Quinceanera Gown Dresses
Yellow Green Ball Sweetheart Taffeta Quinceanera Gown Dresses
Lilac Ball Gown Strapless Sweet 16 Dresses with Embroidery
Gorgeous Green Strapless Ball Gown Organza Quinceanera Dresses
Teal Ball Gown Tulle Sweet Sixteen Dresses with Appliques
Coral Red Sweetheart Ball Gown Quinceneara Dresses with Sequins Katy Perry dress
Purple Floor-length Taffeta Quinceanera Dresses with Pick-ups